package com.example.librarysystem.Service;

import com.example.librarysystem.entity.Order;
import com.example.librarysystem.entity.OrderInfo;

import java.sql.Date;
import java.util.List;

public interface OrderService {
    Integer selectCount();
    List<OrderInfo> selectOrderInfo(int borrowerId, int currentPage, int pageSize);
    List<OrderInfo> selectOrderInfoSearch(int borrowerId, String bookName, String author, String publishingHouse, int currentPage, int pageSize);
    int deleteOrderById(int id);
    List<Order> selectByBookName(String bookName);
    List<Order> selectByBookIdAndEndDate(int bookId, Date endDate);
    int insertOrder(Order order);
    int selectOrderInfoCount(int borrowerId);
    int selectOrderInfoSearchCount(int borrowerId, String bookName, String author, String publishingHouse);
    List<Order> selectAll(int currentPage, int pageSize);
    Order selectOrderById(int id);
    List<Order> selectOrderBetween(Date start, Date end);
    List<Order> selectOrderOver(Date end);
}
